Database Fields Available for Documents
The fields shown here are available for selection on the Document Maintenance dialog for insertion into a document.
VoterName |
Voter's name formatted as Last-Name, First-Name Middle-Name Style-Suffix. Note: For line printer
forms where the maximum length of the string is known, this format
is progressively shortened using middle initial, first initial,
and finally dropping name style if necessary.
|
VoterNameLMF |
Voter's name formatted as First-Name Middle-Name Last-Name Style-Suffix. Note: For line printer
forms where the maximum length of the string is known, this format
is progressively shortened using the middle initial, first initial,
and finally dropping name style if necessary.
|
Address1 |
Voter's
mailing address if available, otherwise the first line of the
residence address. |
Address2 |
If the mailing address is available, the next line is shown, otherwise the city, state, and zip code line of the residence address. |
Address3 |
Third line of the mailing address if available. |
Address4 |
Fourth line of the mailing address if available. |
Mail1 |
First line of the mailing address. Blank if no mailing address. |
Mail2 |
Second line of the mailing address. Blank if no mailing address. |
Mail3 |
Third line of the mailing address. Blank if no mailing address. |
MailCtySt |
City, state, and zip code of the mailing address. Blank if no mailing address. |
MailCityName |
Mailing address city. Blank if no mailing address. |
MailState |
Mailing address state. Blank if no mailing address. |
MailZip |
Mailing address zip code. Blank if no mailing address. |
MailCountry |
Mailing address country. Blank if no mailing address. |
Residence |
Formatted residence-address line. |
ResidenceProt |
For voters with a protected address, the text ** Protected ** prints in place of the residence address. The address appears as usual for voters whose address is not protected. |
ResCtySt |
Formatted residence city and state line. |
ResCtyStProt |
For voters with a protected address, the text ** Protected ** prints in place of the city and state of the residence address. The city and state appears as usual for voters whose address is not protected. |
ResCounty |
Voter's county of residence. |
FullResidence |
Full one-line residence address including city name, state, and zip code. |
USPSCity |
USPS city name for residence address. |
Party |
Party code. |
PartyName |
Party name (up to 40 characters). |
Sex |
Sex code. |
Regn Code |
Registration code. |
|
|
BirthDate |
Voter's date of birth. |
BirthPlace |
Voter's state or country of birth. |
Assistance |
Prints a Y for voters with Assistance flag set to Y or an N for voters who do not have the Assistance flag set. |
AssistanceX |
The value specified in Voter Focus Admin > System Options > VC Options > Assistance Required Text for Voter Certificates. |
AssistanceN |
Prints an X if assistance not required. |
AssistanceY |
Prints an X if assistance is required. |
CongDist |
US Congressional district number. |
County |
County Commission seat. |
SchlBrd |
School Board seat. |
Dst-{district} |
Seat number for the district. Note: Your
database will have multiple fields of this type, one for each
district.
|
DSC-{district} |
District type for the district. Note: Your
database will have multiple fields of this type, one for each
district.
|
Short-DSC-{district} |
Short description for the district. Note: Your
database will have multiple fields of this type, one for each
district.
|
Inc-{district} |
Incumbent's name. Note: Your
database will have multiple fields of this type, one for each
district.
|
IncParty-{district} |
Incumbent's party. Note: Your
database will have multiple fields of this type, one for each
district.
|
IncCont-{district} |
Incumbent's contact information. Note: Your
database will have multiple fields of this type, one for each
district.
|
CityCode |
City in which the voter can vote. |
CityName |
City name for which the voter can vote. |
CityLongName |
The full name of the city (20 characters). |
CityWard |
City ward in which the voter can vote. |
TodaysDate |
Date at time of printing. |
Precinct |
Voter's precinct ID. |
PrecinctPart |
Voter's precinct split. |
Status |
Voter's registration status code. |
StatusDesc |
Text description of the voter's status code. |
ReasonCode |
Voter's status reason code. |
ReasonDesc |
Text description of the voter's status reason code. |
PrcLocn |
Place name of the voter's polling place. |
PrcRegionDesc |
Polling place region description. |
PrcAddress |
Street address of a voter's polling place. |
PrcCityStZp |
City, state and zip code for voter's polling place. |
Directions |
Directions to the voter's polling place. |
PersonIC |
Person in charge at the voter's polling place. |
CntctPsn |
Contact person at the voter's polling place. |
WardPlace |
City ward place name. |
WardLocn |
City ward place address. |
WardDirections |
City ward directions. |
CreationDate |
Creation date of the voter's record. |
LastActivity |
Last activity date of the voter. |
StatusChange |
Date the voter status was last changed. |
BarCode |
Prints a bar code on a page printer and MT691 printer. |
CardReason |
Reason for sending voter certificate. |
DenialIncompReason |
Reason for reject of registration or reason why registration is considered incomplete. |
AbsenteeReason |
Reason for rejecting mail ballot request. |
VCrdMsg1 - 16 |
Voter Certificate message lines 1 through 16 (multiple fields). |
ElectionName |
Election name. |
ElectionDate |
Date of election. |
ElectionNumber |
Election number. |
ElectionType |
Election type (Primary or General). |
BallotStyle |
Voter's ballot style for this election. |
BallotNumber |
Ballot number. |
BallotBarNbr |
Ballot bar code number. |
AbsLabelDataLine |
Absentee data line. |
AbsBarCode |
Absentee bar code. |
PrecWorked |
Poll worker precinct worked. |
PrecPlace |
Poll worker precinct worked place name. |
PrecLocn |
Poll workerprecinct worked address. |
PrecDirections |
Poll worker precinct worked directions. |
PosnCode |
Poll worker position code. |
PosnDescription |
Poll worker position description. |
CheckAmtDigits |
Poll worker payroll check amount in digits. |
CheckAmtWords |
Poll worker payroll check amount in text. |
YTD Amount |
Poll worker payroll year-to-date pay. |
PayDesc1 - 6 |
Poll worker payroll description of pay item 1 through 6 (multiple fields). |
ReplacesCheck |
Poll worker payroll check "replaces check 9999999." |
LastName |
Registration form - voter's last name. |
FirstName |
Registration form - voter's first name. |
MiddleName |
Registration form - voter's middle name. |
NameStyle |
Registration form - voter's name style. |
ResAddrNoAppt |
Registration form - Residence address without apartment number. |
Apartment |
Registration form - voter's apartment number. |
ResZip |
Registration form - voter's zip code. |
SSN4Digits |
Registration form - voter's social security number (last 4 digits only). |
SSN9Digits |
Voter's social security number (all 9 digits). |
NoDsn-NoSSN |
Voter claims no driver license or social security number. |
HomePhone |
Voter's home phone number. |
DriversLicense |
Voter's driver license number. |
<party name>X |
Registration form - prints "X" in box for voter's party (Dem, Rep, NPA, or Other). |
OtherParty |
Registration form - prints name of the other party. |
Sex<sex name>X |
Registration form - prints "X" in box for voter's sex. |
FormerName |
Registration form - voter's former name. |
FormerNameOnly |
Registration form - voter's former name (blank if there are entries in the former address fields). |
FormerAddr1 - 3 |
Registration form - voter's former address lines 1 through 3 (multiple fields). |
FormerCity |
Registration form - voter's former city. |
FormerCounty |
Registration form - voter's former county of residence. |
FormerState |
Registration form - voter's former state. |
FormerZip |
Registration form - voter's former zip code. |
CountyName |
Your county name. |
PWInterested |
Voter is interested in election work. |
MilitaryX |
Prints "X" for military voters. |
MilitaryDepX |
Prints "X" for military dependent voters. |
OverseasX |
Prints "X" for overseas voter civilian voters. |
AbAddress1-5 |
Ballot By Mail address lines 1 through 5 (multiple fields). |
AbsFontBarCode |
Ballot By Mail Windows-font bar code. |
PetAddrNoApt |
Petition address change - address line without apartment. |
PetAddrApt |
Petition address change - address line with apartment. |
PetAddrCityName |
Petition address change - city name. |
PetAddrZip |
Petition address change - zip code. |
PetitionName |
Petition address change - petition name. |
PrvnlTracking |
Provisional ballot tracking number. |
ProvisionalReason |
Reason for provisional ballot. |
PrvnlTabulated |
Provisional ballot accepted. |
PrvnlFindings |
Provisional ballot findings. |
PrvnlRejReason |
Reason provisional ballot was rejected. |
PublicEmailAddress |
Voter's email address from the Maint tab of their record. |
ValidFromDate |
The date when a voter becomes eligible to participate in an election, which is 30 days after their application was initially submitted. This date appears on the Activity tab in Voter Maintenance. |